﻿-- Klassenbuch Online - Datenbankschemata
-- Diese Datei wurde mit folgendem Befehl generiert:
-- mysqldump --user=root --password=XXXXXXX -d klassenbuch > KBO_Schema_V1_0.sql
-- !!!!!!!!!!! ACHTUNG !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-- Dieses Skript enthält DROP Statements. Es werden also alle Tabellen gelöscht 
-- und dann neu angelegt.
-- Bitte führen Sie dieses Skript nur bei Neuanlage aus.
-- !!!!!!!!!!! ACHTUNG !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-- MySQL dump 10.9
-- 
-- Host: localhost    Database: klassenbuch
-- ------------------------------------------------------
-- Server version	4.1.18-nt

--
-- Datenbank: `klassenbuch`
--
-- Die folgende Zeit ist zur Sicherheit auskommentiert.
-- Bitte entfernen Sie den Kommentar, wenn Sie die Datenbank
-- mit diesem Skript wirklich neu erstellen wollen.
--
-- use klassenbuch;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `kbo_abteilungen`
--

DROP TABLE IF EXISTS `kbo_abteilungen`;
CREATE TABLE `kbo_abteilungen` (
  `id` int(4) NOT NULL auto_increment,
  `abteilung` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_abteilungszuordnung`
--

DROP TABLE IF EXISTS `kbo_abteilungszuordnung`;
CREATE TABLE `kbo_abteilungszuordnung` (
  `id` int(4) NOT NULL auto_increment,
  `benutzer_id` int(4) NOT NULL default '0',
  `abteilungs_id` int(4) NOT NULL default '0',
  `leiter` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_adminvorgaben`
--

DROP TABLE IF EXISTS `kbo_adminvorgaben`;
CREATE TABLE `kbo_adminvorgaben` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `zensuren_use` int(1) unsigned default '1',
  `zensuren_see` int(1) unsigned default NULL,
  `unterrichtsinhalte_see` int(1) unsigned default NULL,
  `unterrichtsinhalte_use` int(1) unsigned default '1',
  `anwesenheit_see` int(1) unsigned default NULL,
  `anwesenheit_use` int(1) unsigned default '1',
  `timetable_use` int(1) default '1',
  `sonderspalte1_name` varchar(17) NOT NULL default '',
  `sonderspalte2_name` varchar(17) NOT NULL default '',
  `sonderspalte3_name` varchar(17) NOT NULL default '',
  `sonderspalte1_use` int(1) default NULL,
  `sonderspalte2_use` int(1) default NULL,
  `sonderspalte3_use` int(1) default NULL,
  `pupil_see` int(1) unsigned default '1',
  `profilbilder` int(1) default NULL,
  `foto_maxsize` int(7) NOT NULL default '102400',
  `schulname` text NOT NULL,
  `email_kbo` text NOT NULL,
  `email_schule` text NOT NULL,
  `stundendauer` int(11) NOT NULL default '45',
  `pw_mindestlaenge` int(2) NOT NULL default '0',
  `ssl_protection` int(1) default '0',
  `notice` int(1) NOT NULL default '1',
  `tempmarks` int(1) NOT NULL default '1',
  `tendenz` int(1) NOT NULL default '1',
  `note_best` tinyint(3) NOT NULL default '1',
  `note_worst` tinyint(3) NOT NULL default '6',
  `timetable_uselevel` int(1) NOT NULL default '1',
  `weekend` tinyint(1) NOT NULL default '0',
  `ihk_passwort` varchar(100) NOT NULL default '',
  `email_hausaufgaben` int(1) NOT NULL default '0',
  `rssfeed` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_anwesenheit`
--

DROP TABLE IF EXISTS `kbo_anwesenheit`;
CREATE TABLE `kbo_anwesenheit` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `klasse_id` int(10) default NULL,
  `benutzer_id` int(10) unsigned default NULL,
  `dauer` int(10) unsigned default NULL,
  `grund` varchar(20) default NULL,
  `entschuldigt` int(10) unsigned default NULL,
  `verspaetung_min` int(4) default NULL,
  `anwesend` int(1) default NULL,
  `entlassen` int(1) default NULL,
  `vorzeitig_entlassen_time` time default NULL,
  `tag` int(2) default NULL,
  `monat` int(2) default NULL,
  `jahr` int(4) default NULL,
  `geaendert_benutzer_id` int(10) default NULL,
  `date_timestamp` int(12) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_benutzer`
--

DROP TABLE IF EXISTS `kbo_benutzer`;
CREATE TABLE `kbo_benutzer` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `vorname` varchar(30) default NULL,
  `nachname` varchar(50) default NULL,
  `geburtsdatum` int(11) default NULL,
  `strasse` varchar(80) default NULL,
  `hausnummer` varchar(5) default NULL,
  `plz` int(10) unsigned default NULL,
  `ort` varchar(80) default NULL,
  `telefonnummer` varchar(20) default NULL,
  `handynummer` varchar(25) default NULL,
  `betrieb` int(10) unsigned default NULL,
  `rechtelevel` int(2) unsigned default NULL,
  `bild` int(1) NOT NULL default '0',
  `email` varchar(150) default NULL,
  `konfession` int(10) unsigned default '1',
  `beruf` int(10) unsigned default NULL,
  `pin` varchar(32) default NULL,
  `passwort` varchar(32) default '098f6bcd4621d373cade4e832627b4f6',
  `benutzername` varchar(50) default NULL,
  `ident` varchar(32) NOT NULL default '',
  `lastlogin` int(11) NOT NULL default '0',
  `counter_logins` int(11) NOT NULL default '0',
  `ausgeschult` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_berufe`
--

DROP TABLE IF EXISTS `kbo_berufe`;
CREATE TABLE `kbo_berufe` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `berufsbezeichnung` varchar(50) default NULL,
  `fachrichtung` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_betriebe`
--

DROP TABLE IF EXISTS `kbo_betriebe`;
CREATE TABLE `kbo_betriebe` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `betriebsname` varchar(100) default NULL,
  `strasse` varchar(80) default NULL,
  `hausnummer` varchar(5) default NULL,
  `plz` int(10) unsigned default NULL,
  `ort` varchar(80) default NULL,
  `telefonnummer` varchar(80) default NULL,
  `faxnummer` varchar(80) default NULL,
  `email` varchar(120) default NULL,
  `ansprechpartner` varchar(100) default NULL,
  `ansprechpartner_telefon` varchar(50) default NULL,
  `ansprechpartner_email` varchar(120) default NULL,
  `ihk_ident` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_connectionkeys`
--

DROP TABLE IF EXISTS `kbo_connectionkeys`;
CREATE TABLE `kbo_connectionkeys` (
  `id` int(11) NOT NULL auto_increment,
  `connectionkey` varchar(100) collate latin1_german1_ci NOT NULL default '',
  `zeitstempel` varchar(20) collate latin1_german1_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='enthÃ¤lt die zuletzt benutzten connectionkeys';

--
-- Table structure for table `kbo_endnoten`
--

DROP TABLE IF EXISTS `kbo_endnoten`;
CREATE TABLE `kbo_endnoten` (
  `id` mediumint(9) NOT NULL auto_increment,
  `benutzer_id` mediumint(9) NOT NULL default '0',
  `class_id` int(10) NOT NULL default '0',
  `fach_id` mediumint(9) NOT NULL default '0',
  `lehrer_id` mediumint(9) NOT NULL default '0',
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  `note` int(3) NOT NULL default '0',
  `term` int(1) NOT NULL default '0',
  `schoolyear` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_endnoten_history`
--

DROP TABLE IF EXISTS `kbo_endnoten_history`;
CREATE TABLE `kbo_endnoten_history` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `schoolyear` int(4) unsigned NOT NULL default '0',
  `teacher_id` int(10) unsigned NOT NULL default '0',
  `class_id` int(10) NOT NULL default '0',
  `course_id` int(10) NOT NULL default '0',
  `mark_vars` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `mark_vars` (`mark_vars`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_faecher`
--

DROP TABLE IF EXISTS `kbo_faecher`;
CREATE TABLE `kbo_faecher` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fach` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_hilfe`
--

DROP TABLE IF EXISTS `kbo_hilfe`;
CREATE TABLE `kbo_hilfe` (
  `id` tinyint(4) NOT NULL auto_increment,
  `titel` text NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `titel` (`titel`,`text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_klassen`
--

DROP TABLE IF EXISTS `kbo_klassen`;
CREATE TABLE `kbo_klassen` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `klasse` varchar(15) default NULL,
  `abteilungs_id` int(4) NOT NULL default '0',
  `einstellungsdatum` int(11) default NULL,
  `klassenlehrer` int(10) unsigned default NULL,
  `klassensprecher` int(10) unsigned default NULL,
  `klassenlehrer_vertreter` int(10) unsigned default NULL,
  `klassensprecher_vertreter` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_klassenzuordnung`
--

DROP TABLE IF EXISTS `kbo_klassenzuordnung`;
CREATE TABLE `kbo_klassenzuordnung` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `benutzer_id` int(10) unsigned default NULL,
  `klassen_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_konfessionen`
--

DROP TABLE IF EXISTS `kbo_konfessionen`;
CREATE TABLE `kbo_konfessionen` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `konfession` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_lehrerzuordnung`
--

DROP TABLE IF EXISTS `kbo_lehrerzuordnung`;
CREATE TABLE `kbo_lehrerzuordnung` (
  `lehrer_id` int(11) NOT NULL default '0',
  `fach_id` int(11) NOT NULL default '0',
  `klassen_id` int(11) NOT NULL default '0',
  `plan_id` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `lehrer_id` (`lehrer_id`,`fach_id`,`klassen_id`,`plan_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_lerninhalte`
--

DROP TABLE IF EXISTS `kbo_lerninhalte`;
CREATE TABLE `kbo_lerninhalte` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tag` int(2) unsigned default NULL,
  `monat` int(2) unsigned default NULL,
  `jahr` int(4) unsigned default NULL,
  `klasse` int(3) unsigned default NULL,
  `stunde` int(2) unsigned default NULL,
  `thema` text,
  `lehrer` int(4) unsigned default NULL,
  `hausaufgaben` text,
  `bemerkungen` text,
  `sonderspalte1` text NOT NULL,
  `sonderspalte2` text NOT NULL,
  `sonderspalte3` text NOT NULL,
  `fach` int(2) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_lerninhalte_archiv`
--

DROP TABLE IF EXISTS `kbo_lerninhalte_archiv`;
CREATE TABLE `kbo_lerninhalte_archiv` (
  `id` int(10) NOT NULL auto_increment,
  `tag` int(2) NOT NULL default '0',
  `monat` int(2) NOT NULL default '0',
  `jahr` int(4) NOT NULL default '0',
  `klasse` int(3) NOT NULL default '0',
  `stunde` int(2) NOT NULL default '0',
  `thema` text collate latin1_german1_ci NOT NULL,
  `lehrer` int(4) NOT NULL default '0',
  `hausaufgaben` text collate latin1_german1_ci NOT NULL,
  `bemerkungen` text collate latin1_german1_ci NOT NULL,
  `sonderspalte1` text collate latin1_german1_ci NOT NULL,
  `sonderspalte2` text collate latin1_german1_ci NOT NULL,
  `sonderspalte3` text collate latin1_german1_ci NOT NULL,
  `fach` int(2) NOT NULL default '0',
  `aenderungsdatum` int(10) NOT NULL default '0',
  `geaendertvon` int(5) NOT NULL default '0',
  `aenderungstyp` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='Archiv fÃ¼r gelÃ¶schte oder geÃ¤nderte DatensÃ¤tze i';

--
-- Table structure for table `kbo_nachrichten`
--

DROP TABLE IF EXISTS `kbo_nachrichten`;
CREATE TABLE `kbo_nachrichten` (
  `nachricht_id` int(10) NOT NULL auto_increment,
  `empfaenger` int(10) NOT NULL default '0',
  `titel` varchar(150) NOT NULL default '',
  `text` text NOT NULL,
  `unread` int(1) NOT NULL default '1',
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`nachricht_id`),
  FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Hier sind alle Nachrichten des System gespeichert';

--
-- Table structure for table `kbo_nachrichten_typen`
--

DROP TABLE IF EXISTS `kbo_nachrichten_typen`;
CREATE TABLE `kbo_nachrichten_typen` (
  `id` int(11) NOT NULL auto_increment,
  `titel` varchar(150) NOT NULL default '',
  `text` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Speicherung von Mitteilungen falls mehrere Empfaenger.';

--
-- Table structure for table `kbo_quartalsnoten`
--

DROP TABLE IF EXISTS `kbo_quartalsnoten`;
CREATE TABLE `kbo_quartalsnoten` (
  `id` mediumint(9) NOT NULL auto_increment,
  `benutzer_id` mediumint(9) NOT NULL default '0',
  `class_id` int(10) NOT NULL default '0',
  `fach_id` mediumint(9) NOT NULL default '0',
  `lehrer_id` mediumint(9) NOT NULL default '0',
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  `note` int(3) NOT NULL default '0',
  `quartal` int(1) NOT NULL default '1',
  `schoolyear` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Hier werden die Noten des Halbjahres 1 und 2 gespeichert';

--
-- Table structure for table `kbo_rechte`
--

DROP TABLE IF EXISTS `kbo_rechte`;
CREATE TABLE `kbo_rechte` (
  `id` int(11) NOT NULL auto_increment,
  `rechtelevel` int(2) unsigned NOT NULL default '0',
  `bezeichnung` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_schuljahre`
--

DROP TABLE IF EXISTS `kbo_schuljahre`;
CREATE TABLE `kbo_schuljahre` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `anfang` int(11) NOT NULL default '0',
  `ende` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Speicherung der Schuljahre';

--
-- Table structure for table `kbo_sessions`
--

DROP TABLE IF EXISTS `kbo_sessions`;
CREATE TABLE `kbo_sessions` (
  `id` mediumint(9) NOT NULL auto_increment,
  `phpsessid` varchar(100) NOT NULL default '',
  `remote_addr` varchar(40) NOT NULL default '',
  `sess_id` mediumint(9) NOT NULL default '0',
  `session` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `session` (`session`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Mit dieser Tabelle kann spaeter die Session geprueft werden';

--
-- Table structure for table `kbo_stundenplan`
--

DROP TABLE IF EXISTS `kbo_stundenplan`;
CREATE TABLE `kbo_stundenplan` (
  `id` int(11) NOT NULL auto_increment,
  `jahr` varchar(4) NOT NULL default '',
  `klassen_id` tinyint(4) NOT NULL default '0',
  `active` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `jahr` (`jahr`,`klassen_id`,`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_stundenplan_changinginterval`
--

DROP TABLE IF EXISTS `kbo_stundenplan_changinginterval`;
CREATE TABLE `kbo_stundenplan_changinginterval` (
  `id` int(10) NOT NULL auto_increment,
  `plan_id1` int(10) NOT NULL default '0',
  `plan_id2` int(10) NOT NULL default '0',
  `intervall` int(2) NOT NULL default '0',
  `lastchangeweek` int(2) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Speicherung der Wochenintervalle wann ein Stundenplan geaend';

--
-- Table structure for table `kbo_stundenplan_faecher`
--

DROP TABLE IF EXISTS `kbo_stundenplan_faecher`;
CREATE TABLE `kbo_stundenplan_faecher` (
  `id` int(11) NOT NULL auto_increment,
  `plan_id` int(11) NOT NULL default '0',
  `stunde` int(3) NOT NULL default '0',
  `fach_id` int(11) NOT NULL default '0',
  `lehrer_id` mediumint(9) NOT NULL default '0',
  `tag_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_unterricht_zeiten`
--

DROP TABLE IF EXISTS `kbo_unterricht_zeiten`;
CREATE TABLE `kbo_unterricht_zeiten` (
  `id` int(11) NOT NULL auto_increment,
  `stunde` int(11) NOT NULL default '0',
  `von` time NOT NULL default '00:00:00',
  `bis` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- Table structure for table `kbo_zensuren_quartal`
--

DROP TABLE IF EXISTS `kbo_zensuren_quartal`;
CREATE TABLE `kbo_zensuren_quartal` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `benutzer_id` int(10) unsigned default NULL,
  `klassen_id` int(11) NOT NULL default '0',
  `fach_id` int(3) unsigned default NULL,
  `note` int(10) unsigned default NULL,
  `lehrer_id` int(10) unsigned default NULL,
  `tendenz` char(1) default NULL,
  `quartal` int(1) unsigned default NULL,
  `jahr` int(4) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_zwischennoten`
--

DROP TABLE IF EXISTS `kbo_zwischennoten`;
CREATE TABLE `kbo_zwischennoten` (
  `id` int(10) NOT NULL auto_increment,
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  `schueler_id` int(10) NOT NULL default '0',
  `class_id` int(10) NOT NULL default '0',
  `lehrer_id` int(10) NOT NULL default '0',
  `fach_id` int(10) NOT NULL default '0',
  `art_id` tinyint(4) NOT NULL default '0',
  `note` tinyint(4) NOT NULL default '0',
  `tendenz` char(1) default NULL,
  `bemerkung` text NOT NULL,
  `schoolyear` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `bemerkung` (`bemerkung`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Hier werden alle Zwischennoten gespeichert';

--
-- Table structure for table `kbo_zwischennoten_arten`
--

DROP TABLE IF EXISTS `kbo_zwischennoten_arten`;
CREATE TABLE `kbo_zwischennoten_arten` (
  `id` tinyint(4) NOT NULL auto_increment,
  `art` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `art` (`art`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `kbo_zwischennoten_history`
--

DROP TABLE IF EXISTS `kbo_zwischennoten_history`;
CREATE TABLE `kbo_zwischennoten_history` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `schoolyear` int(4) unsigned NOT NULL default '0',
  `teacher_id` int(10) unsigned NOT NULL default '0',
  `class_id` int(10) NOT NULL default '0',
  `course_id` int(10) NOT NULL default '0',
  `action` varchar(50) NOT NULL default '',
  `mark_vars` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `mark_vars` (`mark_vars`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
